package com.team8.system.service.dao;

import com.team8.system.pojo.CheckInTime;
import com.team8.system.pojo.Person;
import org.apache.ibatis.annotations.Select;
import tk.mybatis.mapper.common.Mapper;

import java.util.List;

public interface CheckInTimeDao extends Mapper<CheckInTime> {


    @Select("SELECT person.user_id, person.preson_id, person.person_name, person.id_card, person.gender, person.email FROM ticket_record, `user`, person where `user`.user_id = person.user_id AND ticket_record.person_email = person.email and `user`.user_id = #{userId}")
    List<Person> selectByUserId(String userId);
}
